package com.zxl.working.mapper.backend;

import com.zxl.working.entity.backend.SellerProjectPerson;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Qualifier;

@Mapper
@Qualifier("backEndSqlSessionTemplate")
public interface SellerProjectPersonMapper {

    @Insert("INSERT INTO `backend`.`seller_project_person` (`project_person_id`,`seller_id`," +
            "  `project_id`,`person_info_id`,`status`, `created_time`,`updated_time`)" +
            " VALUES(#{projectPersonId},#{sellerId},#{projectId},#{personInfoId}," +
            "#{status},#{createdTime},#{updatedTime});")
    void insSellerProjectPerson(SellerProjectPerson sellerProjectPerson);

    @Delete("delete from seller_project_person where seller_id=#{orderId}")
    void deleteByOrderId(@Param("orderId")String orderId);
}
